package com.justech.eat.mapper.sqlserver;

import com.justech.eat.entity.AccMonitorLog;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @program: eat-service
 * @description: 就餐记录
 * @author: feifei.li
 * @create: 2020-05-25 14:02
 **/
@Mapper
public interface AccMonitorLogMapper {

    @Select("select * FROM acc_monitor_log where event_point_id in(328,329,330,331)\n" +
            "and create_time>'${date} 10:00:00' and create_time<='${tomorrow} 08:00:00'")
    List<AccMonitorLog> findByDate(String date, String tomorrow);

    @Select("SELECT @@VERSION")
    String version();

    @Select("SELECT * FROM `e_acc_monitor_log` ")
    List<AccMonitorLog> findCurrentBatchLog();
}
